Store Stock Redistribution supports different calculation types to identify the items that need to be redistributed to other stores. The Stock Balancing calculation type calculates the average stock for the items across all stores. Next, based on current stock and the average stock value, the system will balance the stock between the stores and therefore classify locations into locations with demand or supply.
Calculation example
Item 10000 has an inventory in four locations. The Redist. Calculation Type Stock Balancing is redistributing the items between the locations to evenly distribute the stock. Warehouse locations are not considered in this calculation type.
First, the Average Stock is calculated for the item. In a second step every location with Inventory higher than the Average Inventory is considered as a location with supply. The Redist. Stock is the difference between Inventory and Average Inventory. Analogously, locations with Inventory less than the Average Inventory are considered as locations with demand. After reviewing, if needed, you can overwrite the calculated Redist. Stock and Redist. Demand by manually assigning the transfer quantity per item, variant and location in the Retail Item Variant Availability by Location page.
Note: Redist. Demand will be rounded up to the next nearest whole number, and Redist. Stock will be rounded down to the last nearest whole number, if they have a decimal value. In the example above, Redist. Demand of 8,75 will be rounded up to 9, and Redist. Stock of 6,25 will be rounded down to 6.
Setup fields on Redist. Template
| Field | Description |
|---|---|
| Replenishment Type | This field specifies whether the Replenishment Template is to be used for Store Stock Redistribution, or for creating Purchase Orders or Transfer Orders. The selection Redistribution is used for Store Stock Redistribution. |
| Redistribution Calculation Type | This field specifies the type, how the system calculates the Redist. Stock and Redist. Demand. The available values are:
|
| Redistribution Strategy | This field specifies the strategy, how the system calculates the trips between stores with Redist. Stock and Redist. Demand. The available values are:
For more information see Redist. Strategies. |
| Create Journal Lines | This field specifies if the Redist. Journal is calculated in one or two steps. The available values are:
The first option will only calculate the Redist. Preview and the user can review the results, adjust, and calculate the Journal Lines in a manual second step. |
| Date Calculation Type | This field specifies whether the start date will be entered manually or calculated based on a given date formula. |
| Start Date | This field specifies the starting date to be based on when calculating Sell Through % and Average Daily Sales. This is used when the Date Calculation Type is Date. |
| Start Date Formula | This field specifies the formula to calculate the start date to be based on when calculating Sell Through % and Average Daily Sales. This is used when the Date Calculation Type is Date Formula. |
Filters on Redist. Template
In the Redist. Template you can set the filters that you want to apply to the items considered in the calculation.
| Filter | Description |
|---|---|
| Vendor No. Filter | This field specifies a filter for the Vendor No. field of the items. An example is 1000 if you only want to select items from vendor number 1000. If you enter 1000..2000 the system will select all items from vendor number 1000 to 2000. |
| Item Division Code | This field specifies a filter for the Division Code field of the item. |
| Item Category Filter | This field specifies a filter for the Item Category Code field of the item. |
| Item Product Group Filter | This field specifies a filter for the Product Group Code field of the item. |
| Item No. Filter | This field specifies a filter for the item number. |
| Season Filter | This field specifies a filter for the Season Code field of the item. |
| Special Group Code Filter | This field specifies a filter for Special Groups. Only items in these Special Groups will be considered in the calculation. |
| Item Attribute Filter | This field specifies a filter for Attributes. |
| Variant Dimension Filter
|
This field specifies a filter for Variant Dimension Values. |
| From Location Filter
To Location Filter |
This field specifies a filter for From Location and To Location. When Store Stock Redistribution calculates the inventory in the Locations, it classifies Locations into Supply Locations (=From Location Filter) and Demand Locations (=To Location Filter). When the Calculation Type Stock Balancing is used, From Location Filter and To Location Filter always have the same value. Locations that are filtered out will not appear in the Preview and Journal Lines. |
Calculation result
The calculation of Redist. Preview is initiated with the Add Items to Journal/Preview action on the Redistribution Replenishment Journal page.
When the Preview is calculated, the Show Redist. Preview action opens the Redistribution Journal Preview page where you can view the calculated Redist. Demand and Redist. Stock information of the items. Click here for more information on how Redist. Preview is calculated.
From the Redist. Journal Preview, the Show Items Availability action opens up the Retail Item Variant Availability by Location page. There, you view the variant availability and, together with the calculated sales factor (such as Sell Through %), you can determine how the variants can be redistributed among the stores and manually overwrite the calculated Redist. Stock and Redist. Demand, if needed. For more information on how to manually assign Redist. Stock and Redist. Demand, please refer to Retail Item Variant Availability by Location.
Fields on Redistribution Journal Preview
| Field | Description |
|---|---|
| Item No. | This field shows the Item Number. |
| Exclude | Items with this check box selected will be excluded from redistribution trips calculation. |
| Stockout % | This field shows the ratio of out-of-stock item variants to the total number of item variants from all stores. |
| Variant Availability % | This field shows the ratio of in-stock item variants to the total number of item variants from all stores. |
| Eff. Inventory | This field shows the total inventory of the item, considering also the Purchase Orders, Sales Orders, and Transfer Orders that have not been posted. |
| Average Eff. Inventory | This field shows the average effective inventory of the item across all stores. |
| Lowest Eff. Inventory | This field shows the lowest effective inventory of the item across all stores. |
| Highest Eff. Inventory | This field shows the highest effective inventory of the item across all stores. |
| Sell Through % | This field shows the ratio of total sold inventory of the item as of today to its total inventory as of start date. |
| Average Daily Sales | This field shows the calculated average daily sales of the item from the start date until the current date. |
| Standard Deviation | This field shows the standard deviation of the item's effective inventory across all stores. This is used to quantify the amount of variation or dispersion of the item. |
| Relative Std. Deviation | This field shows the ratio of the Standard Deviation to the Average Eff. Inventory. |
| Redist. Stock | This field shows the total redistributable quantity of the item across all stores. |
| Redist. Demand | This field shows the total demand quantity of the item across all stores. |
See Also
Redistribution Calculation Types